DELETE FROM Category

-- Category Table Changes
ALTER TABLE [Category] DROP COLUMN Category_Code
GO
ALTER TABLE [Category] ADD Parent_ID Uniqueidentifier
GO
ALTER TABLE [Category] ADD CategoryListingImage Uniqueidentifier
GO
ALTER TABLE [Category] ADD  CONSTRAINT [DF_Category_Category_ID]  DEFAULT (newid()) FOR [Category_ID]
GO

DECLARE @CategoryID Uniqueidentifier
INSERT INTO Category (Category_Name) VALUES ('Holiday Event')
	SELECT @CategoryID = Category_ID FROM Category WHERE Category_Name = 'Holiday Event'
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('New Year''s', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Easter', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Independence Day', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Thanksgiving', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Christmas', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Memorial Day', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Halloween', @CategoryID)

INSERT INTO Category (Category_Name) VALUES ('Athletic Event')
	SELECT @CategoryID = Category_ID FROM Category WHERE Category_Name = 'Athletic Event'
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Other Athletic', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Running', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Hiking', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Skiing & Snow Shoeing', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Scuba Diving', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Biking', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Rock Climbing', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Kayaking & Rafting', @CategoryID)

INSERT INTO Category (Category_Name) VALUES ('High School & College Event')
	SELECT @CategoryID = Category_ID FROM Category WHERE Category_Name = 'High School & College Event'
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('West Virginia Wesleyan College', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Cardinal Mooney High School', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Rutgers University', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('University of Colorado, Denver', @CategoryID)

INSERT INTO Category (Category_Name) VALUES ('Social Event')
	SELECT @CategoryID = Category_ID FROM Category WHERE Category_Name = 'Social Event'
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Special Event', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Wedding', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Ryan Family Visit', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Other Gathering', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Party', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Harden Family Visit', @CategoryID)

INSERT INTO Category (Category_Name) VALUES ('Miscellaneous')
	SELECT @CategoryID = Category_ID FROM Category WHERE Category_Name = 'Miscellaneous'
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Home Project', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Miscellaneous Event', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Weather Related', @CategoryID)

INSERT INTO Category (Category_Name) VALUES ('Work Event')
	SELECT @CategoryID = Category_ID FROM Category WHERE Category_Name = 'Work Event'
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('FMI', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Access Personnel Services', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Strategic Programs Inc.', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Parker Hannifin', @CategoryID)

INSERT INTO Category (Category_Name) VALUES ('Trip & Vacation Event')
	SELECT @CategoryID = Category_ID FROM Category WHERE Category_Name = 'Trip & Vacation Event'
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Yearly Vacation', @CategoryID)
	INSERT INTO Category (Category_Name, Parent_ID) VALUES ('Weekend Trip', @CategoryID)